[dbo].[PostalCodeRef]

Property	Value
Created	10:31:33 AM Tuesday, March 02, 2010
Last Modified	1:20:16 PM Thursday, February 23, 2012

	Name	Data Type	Max Length (Bytes)
$Indexes IX_PostalCodeRef: PostalCode\CountryCode$	PostalCode	nvarchar(20)	40
$Indexes IX_PostalCodeRef: PostalCode\CountryCode$	CountryCode	nchar(2)	4
	City	nvarchar(50)	100
	StateProvinceCode	nvarchar(5)	10
	Region	nvarchar(50)	100
	County	nvarchar(50)	100
	CountyFIPS	nvarchar(5)	10
	IsHandModified	bit	1
	IsHandEntered	bit	1
	ChapterGroupKey	uniqueidentifier	16
	UpdatedOn	datetime	8
	UpdatedByUserKey	uniqueidentifier	16
	IsActive	bit	1
	PostalCodeKey	uniqueidentifier	16

	Name	Columns	Unique
	PK_PostalCodeRef	PostalCodeKey
	IX_PostalCodeRef	PostalCode, CountryCode
	AK_PostalCodeRef_ChapterGroupKey	ChapterGroupKey
	IX_PostalCodeRef_City	City
	IX_PostalCodeRef_CountryCode	CountryCode
	IX_PostalCodeRef_StateProvinceCode	StateProvinceCode
	IX_PostalCodeRef_UpdatedByUserKey	UpdatedByUserKey

Name	Columns
FK_PostalCodeRef_CountryRef	CountryCode->[dbo].[CountryRef].[CountryCode]
FK_PostalCodeRef_GroupMain_Chapter	ChapterGroupKey->[dbo].[GroupMain].[GroupKey]
FK_PostalCodeRef_UserMain_UpdatedBy	UpdatedByUserKey->[dbo].[UserMain].[UserKey]

SQL Script

CREATE TABLE [dbo].[PostalCodeRef]
(
[PostalCode] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CountryCode] [nchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StateProvinceCode] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Region] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[County] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CountyFIPS] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsHandModified] [bit] NOT NULL,
[IsHandEntered] [bit] NOT NULL,
[ChapterGroupKey] [uniqueidentifier] NULL,
[UpdatedOn] [datetime] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[IsActive] [bit] NOT NULL,
[PostalCodeKey] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[PostalCodeRef] ADD CONSTRAINT [PK_PostalCodeRef] PRIMARY KEY CLUSTERED ([PostalCodeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [AK_PostalCodeRef_ChapterGroupKey] ON [dbo].[PostalCodeRef] ([ChapterGroupKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PostalCodeRef_City] ON [dbo].[PostalCodeRef] ([City]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PostalCodeRef_CountryCode] ON [dbo].[PostalCodeRef] ([CountryCode]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_PostalCodeRef] ON [dbo].[PostalCodeRef] ([PostalCode], [CountryCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PostalCodeRef_StateProvinceCode] ON [dbo].[PostalCodeRef] ([StateProvinceCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PostalCodeRef_UpdatedByUserKey] ON [dbo].[PostalCodeRef] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PostalCodeRef] ADD CONSTRAINT [FK_PostalCodeRef_CountryRef] FOREIGN KEY ([CountryCode]) REFERENCES [dbo].[CountryRef] ([CountryCode])
GO
ALTER TABLE [dbo].[PostalCodeRef] ADD CONSTRAINT [FK_PostalCodeRef_GroupMain_Chapter] FOREIGN KEY ([ChapterGroupKey]) REFERENCES [dbo].[GroupMain] ([GroupKey])
GO
ALTER TABLE [dbo].[PostalCodeRef] ADD CONSTRAINT [FK_PostalCodeRef_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO